Visa småbilder

Iveco  »   Sidomarkering

SELECT ph.id as phid, ph.namn as phnamn, ps.namn as psnamn, ps.avantia, ps.original, ps.nr, ps.ar FROM productshead ph, products ps WHERE (avantia <> 'FR13460') AND (ph.menu2 = 429 AND ph.menu1 = 148 AND (LEN(avantia)>3 OR LEN(original)>3) AND ps.rub_id = ph.id) AND Not Exists (SELECT * FROM TblVag_undantag WHERE avantia = u_artnr) ORDER BY ph.namn, ps.namn,ps.ar